Build Simple Member Formulas

The Member Formula Builder lets you create basic member formulas. If you need a complex formula, create it in the Dimension Library.

See also: The Member Formulas section in the Foundation Guides chapter of the Design and Reference Guide .

To launch Member Formula Builder, click Member Formula Builder on the Administrator Solution Tools Home page.

Before building a member formula, ensure the member exists and the Formula Type, either stored or dynamic, is established in the member's properties settings. To select the formula type, click Application> Dimensions, select the member, select Member Properties, and then select the formula type in Settings.

Use FormulaPass1 – FormulaPass16 for stored formulas. Use DynamicCalc and DynamicCalcTextInput for dynamic formulas.